﻿CREATE TABLE [dbo].[AmixTipModDocument] (
    [IDMod]         SMALLINT     IDENTITY (1, 1) NOT NULL,
    [Denumire]      VARCHAR (50) NOT NULL,
    [IDTipDocument] SMALLINT     NOT NULL,
    CONSTRAINT [PK_TipModDocumentAmix] PRIMARY KEY CLUSTERED ([IDMod] ASC),
    CONSTRAINT [FK_TipModDocumentAmix_TipDocument] FOREIGN KEY ([IDTipDocument]) REFERENCES [dbo].[TipDocument] ([IDTipDocument]),
    CONSTRAINT [IX_TipModDocumentAmix] UNIQUE NONCLUSTERED ([IDMod] ASC, [IDTipDocument] ASC)
);

